import pytest
import xlrd

from four.Calc import cl

def add_data():
    wb = xlrd.open_workbook(filename=r"a.xls")
    table = wb.sheet_by_index(0)
    num = table.nrows

    data = []

    for i in range(num):
        data.append(table.row_values(i))
    return data

print(add_data())


class Test_zd1:
    @pytest.mark.parametrize("a,b,c",add_data())
    def test_zd(self,a,b,c):
            so = cl()
            tt=so.add(a,b)
            assert tt == c
